package com.wf.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.wf.domain.PaymentManage;
import com.wf.dto.PayVO;
import com.wf.vo.PaymentDetailsVO;

import java.util.List;

/**
* @author mpk16
* @description 针对表【payment_manage】的数据库操作Mapper
* @createDate 2024-08-04 15:51:38
* @Entity com.wf.domain.PaymentManage
*/
public interface PaymentManageMapper extends BaseMapper<PaymentManage> {


    /**
     * 查询未交费
     * @param houseId 房屋id
     * @return
     */
    //TODO 可以优化为一条sql 添加if 并再添加一个传递的参数
    List<PaymentDetailsVO> unpaid(Long houseId);

    /**
     * 查询已缴费
     * @param houseId 房屋id
     * @return
     */
    List<PaymentDetailsVO> paid(Long houseId);
    List<PayVO> selectAllPay(Long houses_id, Long user_id,Integer contract_id);
    List<PaymentManage> selectPayMess(Long houses_id);
    List<PaymentManage> selectNoPay();

}




